How to: Create a calculated field in a query.
Solution:
Open the query in Design view then select the 'View' menu and select 'Totals'.
1) If the Database window is not active, activate the Database window.
2) Click the 'Queries' tab in the Database window.
Queries tab
3) Select the desired query from the list. (The query becomes highlighted.)
4) Click 'Design'. (The query opens in Design view.)
5) Select the 'View' menu and select 'Totals'. (The Totals row appears in the query design grid.)
Totals row
6) Click in the 'Total' row of the first field for which to calculate a total. (A down arrow appears.)
7) Click on the arrow. (A drop-down list appears.)
8) Select the desired function from the 'Total' drop-down list.
NOTE: The choices are 'Group By', 'Sum', 'Avg', 'Min', 'Max', 'Count', 'StDev', 'Var' 'First', 'Last', 'Expression', and 'Where'.
